October 15, 2018
| BeerName | Beer_ID | ABV | IBU | Style | Ounces | BreweryName | Brewery_ID | City | State |
|---|---|---|---|---|---|---|---|---|---|
| Get Together | 2692 | 0.045 | 50 | American IPA | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Maggie's Leap | 2691 | 0.049 | 26 | Milk / Sweet Stout | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Wall's End | 2690 | 0.048 | 19 | English Brown Ale | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Pumpion | 2689 | 0.060 | 38 | Pumpkin Ale | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Stronghold | 2688 | 0.060 | 25 | American Porter | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
| Parapet ESB | 2687 | 0.056 | 47 | Extra Special / Strong Bitter (ESB) | 16 | NorthGate Brewing | 1 | Minneapolis | MN |
Caption: Here is a quick glance at the head of our merged dataset. You can see we created easy to read captions and merged the two raw datasets with our renames field "Brewery_ID".
| BeerName | Beer_ID | ABV | IBU | Style | Ounces | BreweryName | Brewery_ID | City | State | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2405 | Pilsner Ukiah | 98 | 0.055 | NA | German Pilsener | 12 | Ukiah Brewing Company | 556 | Ukiah | CA |
| 2406 | Heinnieweisse Weissebier | 52 | 0.049 | NA | Hefeweizen | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2407 | Snapperhead IPA | 51 | 0.068 | NA | American IPA | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2408 | Moo Thunder Stout | 50 | 0.049 | NA | Milk / Sweet Stout | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2409 | Porkslap Pale Ale | 49 | 0.043 | NA | American Pale Ale (APA) | 12 | Butternuts Beer and Ale | 557 | Garrattsville | NY |
| 2410 | Urban Wilderness Pale Ale | 30 | 0.049 | NA | English Pale Ale | 12 | Sleeping Lady Brewing Company | 558 | Anchorage | AK |
Caption: Here is a quick glance at the tail of our merged dataset. You can see we created easy to read captions and merged the two raw datasets with our renames field "Brewery_ID".
| State | medianABV | medianIBU | NumBreweries |
|---|---|---|---|
| AK | 0.0560 | 46.0 | 7 |
| AL | 0.0600 | 43.0 | 3 |
| AR | 0.0520 | 39.0 | 2 |
| AZ | 0.0550 | 20.5 | 11 |
| CA | 0.0580 | 42.0 | 39 |
| CO | 0.0605 | 40.0 | 47 |
na_count BeerName 0 Beer_ID 0 ABV 62 IBU 1005 Style 0 Ounces 0 BreweryName 0 Brewery_ID 0 City 0 State 0
missing data points for IBU.
graph which alludes to the highest number of breweries! Colorado contains 47 breweries. California, Oregon, Texas and Washington fall behind with 39, 29, 28, and 23 breweries.
| State | BeerName | City | ABV |
|---|---|---|---|
| CO | Lee Hill Series Vol. 5 - Belgian Style Quadrupel Ale | Boulder | 0.128 |
Series Vol. 5, a Belgian Style Quadrupel Ale produced in Boulder,CO has an ABV of 12.8%
## IBU Distribution
| State | BeerName | City | IBU |
|---|---|---|---|
| OR | Bitter Bitch Imperial IPA | Astoria | 138 |
Oregon has the bitterest beer of any state!
Bitter Bitch Imperial IPA, produced in Astoria, has an IBU of 138!
Min. 1st Qu. Median Mean 3rd Qu. Max. NA's 0.00100 0.05000 0.05600 0.05977 0.06700 0.12800 62
You can see that the median ABV for all beers is roughly 0.056 and the mean ABV is 0.5977. It is also worth noting that there at 62 beers who do not have a recorded ABV. Those beers were not considered in the analysis for ABV.
## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's ## 4.00 21.00 35.00 42.71 64.00 138.00 1005
and the mean IBU is 42.71. It is also worth noting that there at 1005 beers who do not have a recorded IBU. Those beers were not considered in the analysis for IBU.
We recommend: Target Market: Arkansas, Mississippi, and Alabama State Headquarter: Mississippi
at 0.06 (mean= 0.05977), the ideal IBU is roughly 35-40.